INSERT INTO configuration (configuration_id, configuration_key, configuration_value, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) 
VALUES('', 'PRODUCT_INFO_GALLERY', 'dark_rounded', 1002, 25, NULL, '2011-03-24 18:23:17', NULL, NULL);
INSERT INTO configuration (configuration_id, configuration_key, configuration_value, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) 
VALUES('', 'PRODUCT_INFO_GALLERY_SLIDE', 'false', 1002, 26, NULL, '2011-03-24 18:23:17', NULL, 'xtc_cfg_select_option(array(''true'', ''false''), ');

ALTER TABLE categories_description ADD categories_description_footer TEXT NOT NULL AFTER categories_description;

INSERT INTO emails (id, email_name, languages_id, email_address, email_address_name, email_replay_address, email_replay_address_name, email_subject, email_forward, email_content_html, email_content_text, email_backup_html, email_backup_text, email_timestamp) 
VALUES
(NULL, 'askaquestion', 1, 'mail@ihr-shop.de', 'commerce:SEO', '', '', 'Frage zum Produkt', '', '<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">\r\n<html xmlns="http://www.w3.org/1999/xhtml" dir="ltr" xml:lang="de" lang="de">\r\n<head>\r\n<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />\r\n<title>Kontoeröffnung</title>\r\n{literal}\r\n<style type="text/css">\r\nbody, table {font-size:11.5px; font-family:Helvetica, sans-serif;color:#444}\r\ntable.outerTable {border: 1px solid #ccc}\r\ntd.TopRightDesc {letter-spacing: 1px; font-weight: 600}\r\n.lightBackground td {color:#6d88b1;background: #f1f1f1}\r\n.bt {border-top:1px solid #ccc}\r\n.bb {border-bottom:1px solid #ccc}\r\n.bl {border-left:1px solid #ccc}\r\n.br {border-right:1px solid #ccc}\r\n.fs85 {font-size:85%}\r\n</style>\r\n{/literal}\r\n</head>\r\n<body>\r\n<table width="90%" border="0" cellpadding="10" cellspacing="0" align="center" class="outerTable">\r\n  <tr>\r\n    <td>\r\n      <table width="100%" border="0" cellpadding="0" cellspacing="0">\r\n        <tr>\r\n          <td width="50%">\r\n            <img src="{$logo_path}logo.gif" alt="" />\r\n          </td>\r\n          <td width="50%" class="TopRightDesc" align="right">\r\n            Frage zum Produkt\r\n          </td>\r\n        </tr>\r\n      </table>\r\n    </td>\r\n  </tr>\r\n  <tr>\r\n    <td><br />\r\n      <table width="100%" border="0" cellpadding="10" cellspacing="5" align="center" class="outerTable ">\r\n        <tr class="lightBackground">\r\n          <td width="1"><nobr>Produktname:</nobr></td>\r\n          <td> {$PRODUCT_NAME}</td>\r\n        </tr>\r\n        <tr class="lightBackground">\r\n          <td width="1"><nobr> von:</nobr></td>\r\n          <td> {$FROM_EMAIL_ADDRESS}</td>\r\n        </tr>\r\n        <tr class="lightBackground">\r\n          <td> Name:</td>\r\n          <td> {$TEXT_NAME}</td>\r\n        </tr>\r\n        <tr class="lightBackground">\r\n          <td>Produkt:</td>\r\n          <td><a href="{$PRODUCT_LINK}">{$PRODUCT_LINK}</a></td>\r\n        </tr>\r\n        <tr class="lightBackground">\r\n          <td> Nachricht:</td>\r\n          <td> {$MESSAGE}</td>\r\n        </tr>\r\n      </table>\r\n      <br /><br />\r\n    </td>\r\n  </tr>\r\n</table>', 'Frage zu Artikel:\r\n\r\n{$PRODUCT_NAME}\r\n\r\nvon: {$FROM_EMAIL_ADDRESS}\r\nName: {$TEXT_NAME}\r\nProdukt: {$PRODUCT_LINK}\r\n\r\nNachricht:\r\n{$MESSAGE}\r\n', '<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">\r\n<html xmlns="http://www.w3.org/1999/xhtml" dir="ltr" xml:lang="de" lang="de">\r\n<head>\r\n<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />\r\n<title>Kontoeröffnung</title>\r\n{literal}\r\n<style type="text/css">\r\nbody, table {font-size:11.5px; font-family:Helvetica, sans-serif;color:#444}\r\ntable.outerTable {border: 1px solid #ccc}\r\ntd.TopRightDesc {letter-spacing: 1px; font-weight: 600}\r\n.lightBackground td {color:#6d88b1;background: #f1f1f1}\r\n.bt {border-top:1px solid #ccc}\r\n.bb {border-bottom:1px solid #ccc}\r\n.bl {border-left:1px solid #ccc}\r\n.br {border-right:1px solid #ccc}\r\n.fs85 {font-size:85%}\r\n</style>\r\n{/literal}\r\n</head>\r\n<body>\r\n<table width="90%" border="0" cellpadding="10" cellspacing="0" align="center" class="outerTable">\r\n  <tr>\r\n    <td>\r\n      <table width="100%" border="0" cellpadding="0" cellspacing="0">\r\n        <tr>\r\n          <td width="50%">\r\n            <img src="{$logo_path}logo.gif" alt="" />\r\n          </td>\r\n          <td width="50%" class="TopRightDesc" align="right">\r\n            Frage zum Produkt\r\n          </td>\r\n        </tr>\r\n      </table>\r\n    </td>\r\n  </tr>\r\n  <tr>\r\n    <td><br />\r\n      <table width="100%" border="0" cellpadding="10" cellspacing="5" align="center" class="outerTable ">\r\n        <tr class="lightBackground">\r\n          <td width="1"><nobr>Produktname:</nobr></td>\r\n          <td> {$PRODUCT_NAME}</td>\r\n        </tr>\r\n        <tr class="lightBackground">\r\n          <td width="1"><nobr> von:</nobr></td>\r\n          <td> {$FROM_EMAIL_ADDRESS}</td>\r\n        </tr>\r\n        <tr class="lightBackground">\r\n          <td> Name:</td>\r\n          <td> {$TEXT_NAME}</td>\r\n        </tr>\r\n        <tr class="lightBackground">\r\n          <td>Produkt:</td>\r\n          <td><a href="{$PRODUCT_LINK}">{$PRODUCT_LINK}</a></td>\r\n        </tr>\r\n        <tr class="lightBackground">\r\n          <td> Nachricht:</td>\r\n          <td> {$MESSAGE}</td>\r\n        </tr>\r\n      </table>\r\n      <br /><br />\r\n    </td>\r\n  </tr>\r\n</table>', 'Frage zu Artikel:\r\n\r\n{$PRODUCT_NAME}\r\n\r\nvon: {$FROM_EMAIL_ADDRESS}\r\nName: {$TEXT_NAME}\r\nProdukt: {$PRODUCT_LINK}\r\n\r\nNachricht:\r\n{$MESSAGE}\r\n', 12345612);



ALTER TABLE products_description ADD products_google_taxonomie TEXT NULL , ADD products_taxonomie TEXT NULL;